sqlx4k-mysql/io.github.smyrgeorge.sqlx4k.mysql/[native]MySQL

MySQL

class MySQL(url: String, username: String, password: String, options: ERROR CLASS: Symbol not found for ConnectionPool.Options = ConnectionPool.Options(), val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry = ValueEncoderRegistry()) : IMySQL(source)

The MySQL class provides a driver implementation for interacting with a MySQL database. It supports connection pooling, transactional operations, and executing SQL queries.

The connection URL should follow the nex pattern, as described by MySQL.

The generic format of the connection URL: mysql:///database?properties

Parameters

url

The connection URL for the MySQL database.

username

The username for authenticating with the database.

password

The password for authenticating with the database.

options

The optional configuration for the connection pool, such as min/max connections and timeout settings.

encoders

Optional registry of value encoders to use for encoding query parameters.

Constructors

MySQL

constructor(url: String, username: String, password: String, options: ERROR CLASS: Symbol not found for ConnectionPool.Options = ConnectionPool.Options(), encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry = ValueEncoderRegistry())

Types

SqlxConnection

class SqlxConnection(rt: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, cn: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry) : <ERROR CLASS> ERROR CLASS: Symbol not found for Connection

SqlxTransaction

class SqlxTransaction(rt: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, tx: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry) : <ERROR CLASS> ERROR CLASS: Symbol not found for Transaction

Properties

encoders

open override val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry

Functions

acquire

open suspend override fun acquire(): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Connection>

begin

open suspend override fun begin(): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Transaction>

open suspend override fun close(): ERROR CLASS: Symbol not found for Result<kotlin/Unit>

execute

open suspend override fun execute(sql: String): ERROR CLASS: Symbol not found for Result<kotlin/Long>

fetchAll

open suspend override fun fetchAll(sql: String): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for ResultSet>

migrate

open suspend override fun migrate(path: String, table: String, schema: String?, createSchema: Boolean, afterStatementExecution: suspend (ERROR CLASS: Symbol not found for Statement, ERROR CLASS: Symbol not found for Duration) -> Unit, afterFileMigration: suspend (ERROR CLASS: Symbol not found for Migration, ERROR CLASS: Symbol not found for Duration) -> Unit): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Migrator.Results>

poolIdleSize

open override fun poolIdleSize(): Int

poolSize

open override fun poolSize(): Int